CREATE PROCEDURE ActivarPersonal
@cod_pers int
AS
BEGIN
UPDATE Personal set Activacion = 'SI' WHERE Cod_Personal = @cod_pers
END